Overview
Brought to you by YData
Dataset statistics
| Number of variables | 19 |
|---|---|
| Number of observations | 10000 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 6.2 MiB |
| Average record size in memory | 653.2 B |
Variable types
| Text | 1 |
|---|---|
| Categorical | 6 |
| Numeric | 9 |
| Boolean | 3 |
avg_data_usage_gb is highly overall correlated with monthly_spend and 1 other fields | High correlation |
duration is highly overall correlated with product_id and 1 other fields | High correlation |
gaming is highly overall correlated with product_id and 2 other fields | High correlation |
monthly_spend is highly overall correlated with avg_data_usage_gb and 1 other fields | High correlation |
product_id is highly overall correlated with duration and 5 other fields | High correlation |
product_name is highly overall correlated with duration and 5 other fields | High correlation |
social_media is highly overall correlated with product_id and 2 other fields | High correlation |
spending_tier is highly overall correlated with avg_data_usage_gb and 1 other fields | High correlation |
streaming is highly overall correlated with product_id and 2 other fields | High correlation |
target_offer is highly overall correlated with gaming and 4 other fields | High correlation |
customer_id has unique values | Unique |
travel_score has unique values | Unique |
pct_video_usage has 236 (2.4%) zeros | Zeros |
topup_freq has 476 (4.8%) zeros | Zeros |
complaint_count has 6132 (61.3%) zeros | Zeros |
Reproduction
| Analysis started | 2025-11-13 17:17:37.149284 |
|---|---|
| Analysis finished | 2025-11-13 17:18:00.162038 |
| Duration | 23.01 seconds |
| Software version | ydata-profiling vv4.17.0 |
| Download configuration | config.json |
Variables
customer_id
Text
Unique
| Distinct | 10000 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 537.2 KiB |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 6 |
| Min length | 6 |
Unique
| Unique | 10000 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | C00001 |
|---|---|
| 2nd row | C00002 |
| 3rd row | C00003 |
| 4th row | C00004 |
| 5th row | C00005 |
| Value | Count | Frequency (%) |
| c00001 | 1 | < 0.1% |
| c00009 | 1 | < 0.1% |
| c00018 | 1 | < 0.1% |
| c00003 | 1 | < 0.1% |
| c00004 | 1 | < 0.1% |
| c00005 | 1 | < 0.1% |
| c00006 | 1 | < 0.1% |
| c00007 | 1 | < 0.1% |
| c00008 | 1 | < 0.1% |
| c00010 | 1 | < 0.1% |
| Other values (9990) | 9990 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 13999 | |
| C | 10000 | |
| 1 | 4001 | 6.7% |
| 6 | 4000 | 6.7% |
| 7 | 4000 | 6.7% |
| 4 | 4000 | 6.7% |
| 5 | 4000 | 6.7% |
| 8 | 4000 | 6.7% |
| 9 | 4000 | 6.7% |
| 2 | 4000 | 6.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 60000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 13999 | |
| C | 10000 | |
| 1 | 4001 | 6.7% |
| 6 | 4000 | 6.7% |
| 7 | 4000 | 6.7% |
| 4 | 4000 | 6.7% |
| 5 | 4000 | 6.7% |
| 8 | 4000 | 6.7% |
| 9 | 4000 | 6.7% |
| 2 | 4000 | 6.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 60000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 13999 | |
| C | 10000 | |
| 1 | 4001 | 6.7% |
| 6 | 4000 | 6.7% |
| 7 | 4000 | 6.7% |
| 4 | 4000 | 6.7% |
| 5 | 4000 | 6.7% |
| 8 | 4000 | 6.7% |
| 9 | 4000 | 6.7% |
| 2 | 4000 | 6.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 60000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 13999 | |
| C | 10000 | |
| 1 | 4001 | 6.7% |
| 6 | 4000 | 6.7% |
| 7 | 4000 | 6.7% |
| 4 | 4000 | 6.7% |
| 5 | 4000 | 6.7% |
| 8 | 4000 | 6.7% |
| 9 | 4000 | 6.7% |
| 2 | 4000 | 6.7% |
plan_type
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 550.8 KiB |
| Prepaid | |
|---|---|
| Postpaid |
Length
| Max length | 8 |
|---|---|
| Median length | 7 |
| Mean length | 7.3892 |
| Min length | 7 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Prepaid |
|---|---|
| 2nd row | Postpaid |
| 3rd row | Postpaid |
| 4th row | Prepaid |
| 5th row | Prepaid |
Common Values
| Value | Count | Frequency (%) |
| Prepaid | 6108 | |
| Postpaid | 3892 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| prepaid | 6108 | |
| postpaid | 3892 |
Most occurring characters
| Value | Count | Frequency (%) |
| P | 10000 | |
| p | 10000 | |
| a | 10000 | |
| i | 10000 | |
| d | 10000 | |
| r | 6108 | |
| e | 6108 | |
| o | 3892 | 5.3% |
| s | 3892 | 5.3% |
| t | 3892 | 5.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 73892 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| P | 10000 | |
| p | 10000 | |
| a | 10000 | |
| i | 10000 | |
| d | 10000 | |
| r | 6108 | |
| e | 6108 | |
| o | 3892 | 5.3% |
| s | 3892 | 5.3% |
| t | 3892 | 5.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 73892 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| P | 10000 | |
| p | 10000 | |
| a | 10000 | |
| i | 10000 | |
| d | 10000 | |
| r | 6108 | |
| e | 6108 | |
| o | 3892 | 5.3% |
| s | 3892 | 5.3% |
| t | 3892 | 5.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 73892 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| P | 10000 | |
| p | 10000 | |
| a | 10000 | |
| i | 10000 | |
| d | 10000 | |
| r | 6108 | |
| e | 6108 | |
| o | 3892 | 5.3% |
| s | 3892 | 5.3% |
| t | 3892 | 5.3% |
device_brand
Categorical
| Distinct | 7 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 531.9 KiB |
| Realme | |
|---|---|
| Xiaomi | |
| Samsung | |
| Huawei | |
| Vivo | |
| Other values (2) |
Length
| Max length | 7 |
|---|---|
| Median length | 6 |
| Mean length | 5.4513 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Realme |
|---|---|
| 2nd row | Vivo |
| 3rd row | Xiaomi |
| 4th row | Apple |
| 5th row | Huawei |
Common Values
| Value | Count | Frequency (%) |
| Realme | 1509 | |
| Xiaomi | 1458 | |
| Samsung | 1439 | |
| Huawei | 1438 | |
| Vivo | 1395 | |
| Apple | 1386 | |
| Oppo | 1375 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| realme | 1509 | |
| xiaomi | 1458 | |
| samsung | 1439 | |
| huawei | 1438 | |
| vivo | 1395 | |
| apple | 1386 | |
| oppo | 1375 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 5844 | |
| e | 5842 | |
| i | 5749 | |
| p | 5522 | 10.1% |
| m | 4406 | 8.1% |
| o | 4228 | 7.8% |
| l | 2895 | 5.3% |
| u | 2877 | 5.3% |
| R | 1509 | 2.8% |
| X | 1458 | 2.7% |
| Other values (10) | 14183 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 54513 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 5844 | |
| e | 5842 | |
| i | 5749 | |
| p | 5522 | 10.1% |
| m | 4406 | 8.1% |
| o | 4228 | 7.8% |
| l | 2895 | 5.3% |
| u | 2877 | 5.3% |
| R | 1509 | 2.8% |
| X | 1458 | 2.7% |
| Other values (10) | 14183 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 54513 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 5844 | |
| e | 5842 | |
| i | 5749 | |
| p | 5522 | 10.1% |
| m | 4406 | 8.1% |
| o | 4228 | 7.8% |
| l | 2895 | 5.3% |
| u | 2877 | 5.3% |
| R | 1509 | 2.8% |
| X | 1458 | 2.7% |
| Other values (10) | 14183 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 54513 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 5844 | |
| e | 5842 | |
| i | 5749 | |
| p | 5522 | 10.1% |
| m | 4406 | 8.1% |
| o | 4228 | 7.8% |
| l | 2895 | 5.3% |
| u | 2877 | 5.3% |
| R | 1509 | 2.8% |
| X | 1458 | 2.7% |
| Other values (10) | 14183 |
avg_data_usage_gb
Real number (ℝ)
High correlation
| Distinct | 1712 |
|---|---|
| Distinct (%) | 17.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.958883 |
| Minimum | 0.03 |
|---|---|
| Maximum | 39.02 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.3 KiB |
Quantile statistics
| Minimum | 0.03 |
|---|---|
| 5-th percentile | 1.13 |
| Q1 | 2.87 |
| median | 4.99 |
| Q3 | 8.04 |
| 95-th percentile | 14.19 |
| Maximum | 39.02 |
| Range | 38.99 |
| Interquartile range (IQR) | 5.17 |
Descriptive statistics
| Standard deviation | 4.1929093 |
|---|---|
| Coefficient of variation (CV) | 0.70364014 |
| Kurtosis | 2.7748617 |
| Mean | 5.958883 |
| Median Absolute Deviation (MAD) | 2.45 |
| Skewness | 1.3873462 |
| Sum | 59588.83 |
| Variance | 17.580488 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2.39 | 26 | 0.3% |
| 3.02 | 23 | 0.2% |
| 2.16 | 21 | 0.2% |
| 2.65 | 21 | 0.2% |
| 1.78 | 20 | 0.2% |
| 5.62 | 20 | 0.2% |
| 4.18 | 20 | 0.2% |
| 4.69 | 20 | 0.2% |
| 3.27 | 19 | 0.2% |
| 2.05 | 19 | 0.2% |
| Other values (1702) | 9791 |
| Value | Count | Frequency (%) |
| 0.03 | 1 | < 0.1% |
| 0.04 | 2 | |
| 0.06 | 1 | < 0.1% |
| 0.08 | 1 | < 0.1% |
| 0.12 | 1 | < 0.1% |
| 0.13 | 2 | |
| 0.14 | 3 | |
| 0.15 | 3 | |
| 0.16 | 1 | < 0.1% |
| 0.17 | 3 |
| Value | Count | Frequency (%) |
| 39.02 | 1 | |
| 33.15 | 1 | |
| 30.66 | 1 | |
| 30.44 | 1 | |
| 29.97 | 1 | |
| 27.84 | 1 | |
| 26.99 | 1 | |
| 26.92 | 1 | |
| 26.82 | 1 | |
| 26.08 | 1 |
pct_video_usage
Real number (ℝ)
Zeros
| Distinct | 9749 |
|---|---|
| Distinct (%) | 97.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.40263889 |
| Minimum | 0 |
|---|---|
| Maximum | 1 |
| Zeros | 236 |
| Zeros (%) | 2.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.070404882 |
| Q1 | 0.26529046 |
| median | 0.4001155 |
| Q3 | 0.53516088 |
| 95-th percentile | 0.72682106 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0.26987042 |
Descriptive statistics
| Standard deviation | 0.19574145 |
|---|---|
| Coefficient of variation (CV) | 0.48614642 |
| Kurtosis | -0.24568729 |
| Mean | 0.40263889 |
| Median Absolute Deviation (MAD) | 0.13493808 |
| Skewness | 0.11790369 |
| Sum | 4026.3889 |
| Variance | 0.038314717 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 236 | 2.4% |
| 1 | 17 | 0.2% |
| 0.804146026 | 1 | < 0.1% |
| 0.341826802 | 1 | < 0.1% |
| 0.709332363 | 1 | < 0.1% |
| 0.610009213 | 1 | < 0.1% |
| 0.629036856 | 1 | < 0.1% |
| 0.089818063 | 1 | < 0.1% |
| 0.438641899 | 1 | < 0.1% |
| 0.475566051 | 1 | < 0.1% |
| Other values (9739) | 9739 |
| Value | Count | Frequency (%) |
| 0 | 236 | |
| 0.000168478 | 1 | < 0.1% |
| 0.001037455 | 1 | < 0.1% |
| 0.001370626 | 1 | < 0.1% |
| 0.001950845 | 1 | < 0.1% |
| 0.00291208 | 1 | < 0.1% |
| 0.003496372 | 1 | < 0.1% |
| 0.004638417 | 1 | < 0.1% |
| 0.004673963 | 1 | < 0.1% |
| 0.004691242 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 17 | |
| 0.997666702 | 1 | < 0.1% |
| 0.989796185 | 1 | < 0.1% |
| 0.988209616 | 1 | < 0.1% |
| 0.981982115 | 1 | < 0.1% |
| 0.978086539 | 1 | < 0.1% |
| 0.97587673 | 1 | < 0.1% |
| 0.974465945 | 1 | < 0.1% |
| 0.973972507 | 1 | < 0.1% |
| 0.972343273 | 1 | < 0.1% |
avg_call_duration
Real number (ℝ)
| Distinct | 2229 |
|---|---|
| Distinct (%) | 22.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.971357 |
| Minimum | -8.37 |
|---|---|
| Maximum | 27.77 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 229 |
| Negative (%) | 2.3% |
| Memory size | 78.3 KiB |
Quantile statistics
| Minimum | -8.37 |
|---|---|
| 5-th percentile | 1.74 |
| Q1 | 6.65 |
| median | 10.02 |
| Q3 | 13.32 |
| 95-th percentile | 18.02 |
| Maximum | 27.77 |
| Range | 36.14 |
| Interquartile range (IQR) | 6.67 |
Descriptive statistics
| Standard deviation | 4.9549927 |
|---|---|
| Coefficient of variation (CV) | 0.4969226 |
| Kurtosis | -0.0069078222 |
| Mean | 9.971357 |
| Median Absolute Deviation (MAD) | 3.33 |
| Skewness | -0.036472282 |
| Sum | 99713.57 |
| Variance | 24.551952 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10.73 | 19 | 0.2% |
| 11.03 | 18 | 0.2% |
| 12.91 | 15 | 0.1% |
| 10.76 | 15 | 0.1% |
| 9.25 | 15 | 0.1% |
| 8.86 | 15 | 0.1% |
| 11.88 | 14 | 0.1% |
| 8.04 | 14 | 0.1% |
| 10.26 | 14 | 0.1% |
| 9.58 | 14 | 0.1% |
| Other values (2219) | 9847 |
| Value | Count | Frequency (%) |
| -8.37 | 1 | |
| -7.13 | 1 | |
| -7.12 | 1 | |
| -6.94 | 1 | |
| -6.81 | 1 | |
| -6.73 | 1 | |
| -6.68 | 1 | |
| -6.53 | 1 | |
| -6.45 | 1 | |
| -6.04 | 1 |
| Value | Count | Frequency (%) |
| 27.77 | 1 | |
| 27.73 | 1 | |
| 27.3 | 1 | |
| 26.84 | 1 | |
| 26.81 | 1 | |
| 26.32 | 1 | |
| 25.99 | 1 | |
| 25.96 | 1 | |
| 25.89 | 1 | |
| 25.83 | 1 |
sms_freq
Real number (ℝ)
| Distinct | 28 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.0108 |
| Minimum | 4 |
|---|---|
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.3 KiB |
Quantile statistics
| Minimum | 4 |
|---|---|
| 5-th percentile | 9 |
| Q1 | 12 |
| median | 15 |
| Q3 | 18 |
| 95-th percentile | 22 |
| Maximum | 31 |
| Range | 27 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.8727746 |
|---|---|
| Coefficient of variation (CV) | 0.25799921 |
| Kurtosis | 0.090199895 |
| Mean | 15.0108 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.27597848 |
| Sum | 150108 |
| Variance | 14.998383 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 15 | 1029 | |
| 14 | 1000 | |
| 13 | 990 | |
| 16 | 943 | |
| 17 | 859 | |
| 12 | 829 | |
| 18 | 688 | 6.9% |
| 11 | 685 | 6.9% |
| 19 | 575 | 5.8% |
| 10 | 472 | 4.7% |
| Other values (18) | 1930 |
| Value | Count | Frequency (%) |
| 4 | 10 | 0.1% |
| 5 | 15 | 0.1% |
| 6 | 46 | 0.5% |
| 7 | 110 | 1.1% |
| 8 | 191 | 1.9% |
| 9 | 309 | 3.1% |
| 10 | 472 | |
| 11 | 685 | |
| 12 | 829 | |
| 13 | 990 |
| Value | Count | Frequency (%) |
| 31 | 4 | < 0.1% |
| 30 | 1 | < 0.1% |
| 29 | 8 | 0.1% |
| 28 | 4 | < 0.1% |
| 27 | 18 | 0.2% |
| 26 | 32 | 0.3% |
| 25 | 50 | 0.5% |
| 24 | 82 | |
| 23 | 126 | |
| 22 | 199 |
monthly_spend
Real number (ℝ)
High correlation
| Distinct | 308 |
|---|---|
| Distinct (%) | 3.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 109776.5 |
| Minimum | -13000 |
|---|---|
| Maximum | 450000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 2 |
| Negative (%) | < 0.1% |
| Memory size | 78.3 KiB |
Quantile statistics
| Minimum | -13000 |
|---|---|
| 5-th percentile | 49000 |
| Q1 | 78000 |
| median | 102000 |
| Q3 | 135000 |
| 95-th percentile | 196000 |
| Maximum | 450000 |
| Range | 463000 |
| Interquartile range (IQR) | 57000 |
Descriptive statistics
| Standard deviation | 46237.322 |
|---|---|
| Coefficient of variation (CV) | 0.42119508 |
| Kurtosis | 2.038817 |
| Mean | 109776.5 |
| Median Absolute Deviation (MAD) | 28000 |
| Skewness | 1.0602815 |
| Sum | 1.097765 × 109 |
| Variance | 2.1378899 × 109 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 81000 | 124 | 1.2% |
| 82000 | 121 | 1.2% |
| 85000 | 115 | 1.1% |
| 90000 | 113 | 1.1% |
| 95000 | 112 | 1.1% |
| 89000 | 110 | 1.1% |
| 98000 | 105 | 1.1% |
| 100000 | 104 | 1.0% |
| 78000 | 103 | 1.0% |
| 87000 | 103 | 1.0% |
| Other values (298) | 8890 |
| Value | Count | Frequency (%) |
| -13000 | 1 | < 0.1% |
| -6000 | 1 | < 0.1% |
| 2000 | 1 | < 0.1% |
| 5000 | 1 | < 0.1% |
| 7000 | 1 | < 0.1% |
| 8000 | 2 | |
| 9000 | 1 | < 0.1% |
| 12000 | 3 | |
| 13000 | 2 | |
| 14000 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 450000 | 1 | |
| 372000 | 1 | |
| 363000 | 1 | |
| 354000 | 1 | |
| 350000 | 1 | |
| 349000 | 1 | |
| 337000 | 1 | |
| 333000 | 2 | |
| 330000 | 1 | |
| 324000 | 2 |
topup_freq
Real number (ℝ)
Zeros
| Distinct | 12 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.9866 |
| Minimum | 0 |
|---|---|
| Maximum | 12 |
| Zeros | 476 |
| Zeros (%) | 4.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 6 |
| Maximum | 12 |
| Range | 12 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.7098283 |
|---|---|
| Coefficient of variation (CV) | 0.57249993 |
| Kurtosis | 0.32893541 |
| Mean | 2.9866 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.57530473 |
| Sum | 29866 |
| Variance | 2.9235128 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3 | 2293 | |
| 2 | 2236 | |
| 4 | 1701 | |
| 1 | 1512 | |
| 5 | 970 | |
| 6 | 493 | 4.9% |
| 0 | 476 | 4.8% |
| 7 | 209 | 2.1% |
| 8 | 72 | 0.7% |
| 9 | 30 | 0.3% |
| Other values (2) | 8 | 0.1% |
| Value | Count | Frequency (%) |
| 0 | 476 | 4.8% |
| 1 | 1512 | |
| 2 | 2236 | |
| 3 | 2293 | |
| 4 | 1701 | |
| 5 | 970 | |
| 6 | 493 | 4.9% |
| 7 | 209 | 2.1% |
| 8 | 72 | 0.7% |
| 9 | 30 | 0.3% |
| Value | Count | Frequency (%) |
| 12 | 1 | < 0.1% |
| 10 | 7 | 0.1% |
| 9 | 30 | 0.3% |
| 8 | 72 | 0.7% |
| 7 | 209 | 2.1% |
| 6 | 493 | 4.9% |
| 5 | 970 | |
| 4 | 1701 | |
| 3 | 2293 | |
| 2 | 2236 |
travel_score
Real number (ℝ)
Unique
| Distinct | 10000 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.2824407 |
| Minimum | 0.003375549 |
|---|---|
| Maximum | 0.85481359 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.3 KiB |
Quantile statistics
| Minimum | 0.003375549 |
|---|---|
| 5-th percentile | 0.061392273 |
| Q1 | 0.15877515 |
| median | 0.2612058 |
| Q3 | 0.3856562 |
| 95-th percentile | 0.57436417 |
| Maximum | 0.85481359 |
| Range | 0.85143804 |
| Interquartile range (IQR) | 0.22688105 |
Descriptive statistics
| Standard deviation | 0.15836636 |
|---|---|
| Coefficient of variation (CV) | 0.56070658 |
| Kurtosis | -0.090670875 |
| Mean | 0.2824407 |
| Median Absolute Deviation (MAD) | 0.11067369 |
| Skewness | 0.60349188 |
| Sum | 2824.407 |
| Variance | 0.025079903 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.284418997 | 1 | < 0.1% |
| 0.396435784 | 1 | < 0.1% |
| 0.091934321 | 1 | < 0.1% |
| 0.085950298 | 1 | < 0.1% |
| 0.408043587 | 1 | < 0.1% |
| 0.549135717 | 1 | < 0.1% |
| 0.04287208 | 1 | < 0.1% |
| 0.054140744 | 1 | < 0.1% |
| 0.339828978 | 1 | < 0.1% |
| 0.152164423 | 1 | < 0.1% |
| Other values (9990) | 9990 |
| Value | Count | Frequency (%) |
| 0.003375549 | 1 | |
| 0.004111988 | 1 | |
| 0.005014107 | 1 | |
| 0.005295472 | 1 | |
| 0.005297941 | 1 | |
| 0.006518227 | 1 | |
| 0.006590649 | 1 | |
| 0.006789953 | 1 | |
| 0.006900476 | 1 | |
| 0.007161406 | 1 |
| Value | Count | Frequency (%) |
| 0.854813593 | 1 | |
| 0.844166874 | 1 | |
| 0.843125354 | 1 | |
| 0.839215961 | 1 | |
| 0.833735033 | 1 | |
| 0.833201455 | 1 | |
| 0.826561214 | 1 | |
| 0.823822346 | 1 | |
| 0.823366141 | 1 | |
| 0.823009678 | 1 |
complaint_count
Real number (ℝ)
Zeros
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.4926 |
| Minimum | 0 |
|---|---|
| Maximum | 5 |
| Zeros | 6132 |
| Zeros (%) | 61.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.70412699 |
|---|---|
| Coefficient of variation (CV) | 1.4294092 |
| Kurtosis | 1.8459323 |
| Mean | 0.4926 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.4076191 |
| Sum | 4926 |
| Variance | 0.49579482 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 6132 | |
| 1 | 2964 | |
| 2 | 766 | 7.7% |
| 3 | 123 | 1.2% |
| 4 | 14 | 0.1% |
| 5 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 6132 | |
| 1 | 2964 | |
| 2 | 766 | 7.7% |
| 3 | 123 | 1.2% |
| 4 | 14 | 0.1% |
| 5 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 5 | 1 | < 0.1% |
| 4 | 14 | 0.1% |
| 3 | 123 | 1.2% |
| 2 | 766 | 7.7% |
| 1 | 2964 | |
| 0 | 6132 |
product_id
Real number (ℝ)
High correlation
| Distinct | 25 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12.886 |
| Minimum | 1 |
|---|---|
| Maximum | 25 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.3 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 7 |
| median | 13 |
| Q3 | 19 |
| 95-th percentile | 24 |
| Maximum | 25 |
| Range | 24 |
| Interquartile range (IQR) | 12 |
Descriptive statistics
| Standard deviation | 7.1678269 |
|---|---|
| Coefficient of variation (CV) | 0.55624917 |
| Kurtosis | -1.1893821 |
| Mean | 12.886 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 0.024858226 |
| Sum | 128860 |
| Variance | 51.377742 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 7 | 434 | 4.3% |
| 12 | 431 | 4.3% |
| 3 | 426 | 4.3% |
| 14 | 419 | 4.2% |
| 4 | 418 | 4.2% |
| 6 | 412 | 4.1% |
| 18 | 411 | 4.1% |
| 19 | 410 | 4.1% |
| 22 | 407 | 4.1% |
| 10 | 407 | 4.1% |
| Other values (15) | 5825 |
| Value | Count | Frequency (%) |
| 1 | 406 | |
| 2 | 368 | |
| 3 | 426 | |
| 4 | 418 | |
| 5 | 377 | |
| 6 | 412 | |
| 7 | 434 | |
| 8 | 401 | |
| 9 | 402 | |
| 10 | 407 |
| Value | Count | Frequency (%) |
| 25 | 395 | |
| 24 | 369 | |
| 23 | 384 | |
| 22 | 407 | |
| 21 | 365 | |
| 20 | 403 | |
| 19 | 410 | |
| 18 | 411 | |
| 17 | 359 | |
| 16 | 386 |
product_name
Categorical
High correlation
| Distinct | 25 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 865.2 KiB |
| 100gb 220k (internet only 7) | 434 |
|---|---|
| 90gb 240k (60gb internet + 10gb stream + 10gb game + 10gb socmed, pahe 4) | 431 |
| 25gb 80k (internet only 3) | 426 |
| 5gb 10k (internet only harian 1) | 419 |
| 35gb 100k (internet only 4) | 418 |
| Other values (20) |
Length
| Max length | 75 |
|---|---|
| Median length | 59 |
| Mean length | 39.5877 |
| Min length | 26 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 10gb 50k (internet only 1) |
|---|---|
| 2nd row | 20gb 45k (internet + stream mingguan) |
| 3rd row | 10gb 15k (internet only harian 2) |
| 4th row | 15gb 65k (internet only 2) |
| 5th row | 3gb 8k (internet only hemat 1) |
Common Values
| Value | Count | Frequency (%) |
| 100gb 220k (internet only 7) | 434 | 4.3% |
| 90gb 240k (60gb internet + 10gb stream + 10gb game + 10gb socmed, pahe 4) | 431 | 4.3% |
| 25gb 80k (internet only 3) | 426 | 4.3% |
| 5gb 10k (internet only harian 1) | 419 | 4.2% |
| 35gb 100k (internet only 4) | 418 | 4.2% |
| 80gb 200k (internet only 6) | 412 | 4.1% |
| 20gb 45k (internet + stream mingguan) | 411 | 4.1% |
| 12gb 30k (internet only 14 hari 1) | 410 | 4.1% |
| 6gb 20k (internet + game mingguan) | 407 | 4.1% |
| 30gb 100k (25gb internet + 5gb stream + 5gb game, pahe 2) | 407 | 4.1% |
| Other values (15) | 5825 |
Length
| Value | Count | Frequency (%) |
| internet | 10000 | 13.1% |
| 8033 | 10.5% | |
| only | 5607 | 7.4% |
| 10gb | 4475 | 5.9% |
| stream | 4022 | 5.3% |
| 1 | 3177 | 4.2% |
| 5gb | 2406 | 3.2% |
| mingguan | 2323 | 3.0% |
| game | 2050 | 2.7% |
| pahe | 2045 | 2.7% |
| Other values (51) | 32134 |
Most occurring characters
| Value | Count | Frequency (%) |
| 66672 | ||
| n | 31446 | 7.9% |
| e | 30895 | 7.8% |
| t | 24807 | 6.3% |
| g | 24464 | 6.2% |
| 0 | 18423 | 4.7% |
| b | 17768 | 4.5% |
| r | 16028 | 4.0% |
| a | 14424 | 3.6% |
| i | 14329 | 3.6% |
| Other values (24) | 136621 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 395877 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 66672 | ||
| n | 31446 | 7.9% |
| e | 30895 | 7.8% |
| t | 24807 | 6.3% |
| g | 24464 | 6.2% |
| 0 | 18423 | 4.7% |
| b | 17768 | 4.5% |
| r | 16028 | 4.0% |
| a | 14424 | 3.6% |
| i | 14329 | 3.6% |
| Other values (24) | 136621 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 395877 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 66672 | ||
| n | 31446 | 7.9% |
| e | 30895 | 7.8% |
| t | 24807 | 6.3% |
| g | 24464 | 6.2% |
| 0 | 18423 | 4.7% |
| b | 17768 | 4.5% |
| r | 16028 | 4.0% |
| a | 14424 | 3.6% |
| i | 14329 | 3.6% |
| Other values (24) | 136621 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 395877 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 66672 | ||
| n | 31446 | 7.9% |
| e | 30895 | 7.8% |
| t | 24807 | 6.3% |
| g | 24464 | 6.2% |
| 0 | 18423 | 4.7% |
| b | 17768 | 4.5% |
| r | 16028 | 4.0% |
| a | 14424 | 3.6% |
| i | 14329 | 3.6% |
| Other values (24) | 136621 |
spending_tier
Categorical
High correlation
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 509.6 KiB |
| mid | |
|---|---|
| low | |
| high |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 3.1726 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | low |
|---|---|
| 2nd row | low |
| 3rd row | mid |
| 4th row | low |
| 5th row | low |
Common Values
| Value | Count | Frequency (%) |
| mid | 5597 | |
| low | 2677 | |
| high | 1726 | 17.3% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| mid | 5597 | |
| low | 2677 | |
| high | 1726 | 17.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 7323 | |
| m | 5597 | |
| d | 5597 | |
| h | 3452 | |
| l | 2677 | 8.4% |
| o | 2677 | 8.4% |
| w | 2677 | 8.4% |
| g | 1726 | 5.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 31726 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| i | 7323 | |
| m | 5597 | |
| d | 5597 | |
| h | 3452 | |
| l | 2677 | 8.4% |
| o | 2677 | 8.4% |
| w | 2677 | 8.4% |
| g | 1726 | 5.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 31726 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| i | 7323 | |
| m | 5597 | |
| d | 5597 | |
| h | 3452 | |
| l | 2677 | 8.4% |
| o | 2677 | 8.4% |
| w | 2677 | 8.4% |
| g | 1726 | 5.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 31726 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| i | 7323 | |
| m | 5597 | |
| d | 5597 | |
| h | 3452 | |
| l | 2677 | 8.4% |
| o | 2677 | 8.4% |
| w | 2677 | 8.4% |
| g | 1726 | 5.4% |
duration
Categorical
High correlation
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 543.2 KiB |
| 30 hari | |
|---|---|
| 7 hari | |
| 1 hari | |
| 14 hari |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 6.61 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 30 hari |
|---|---|
| 2nd row | 7 hari |
| 3rd row | 1 hari |
| 4th row | 30 hari |
| 5th row | 1 hari |
Common Values
| Value | Count | Frequency (%) |
| 30 hari | 5287 | |
| 7 hari | 2323 | |
| 1 hari | 1577 | 15.8% |
| 14 hari | 813 | 8.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| hari | 10000 | |
| 30 | 5287 | |
| 7 | 2323 | 11.6% |
| 1 | 1577 | 7.9% |
| 14 | 813 | 4.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 10000 | ||
| h | 10000 | |
| a | 10000 | |
| r | 10000 | |
| i | 10000 | |
| 3 | 5287 | |
| 0 | 5287 | |
| 1 | 2390 | 3.6% |
| 7 | 2323 | 3.5% |
| 4 | 813 | 1.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 66100 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 10000 | ||
| h | 10000 | |
| a | 10000 | |
| r | 10000 | |
| i | 10000 | |
| 3 | 5287 | |
| 0 | 5287 | |
| 1 | 2390 | 3.6% |
| 7 | 2323 | 3.5% |
| 4 | 813 | 1.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 66100 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 10000 | ||
| h | 10000 | |
| a | 10000 | |
| r | 10000 | |
| i | 10000 | |
| 3 | 5287 | |
| 0 | 5287 | |
| 1 | 2390 | 3.6% |
| 7 | 2323 | 3.5% |
| 4 | 813 | 1.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 66100 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 10000 | ||
| h | 10000 | |
| a | 10000 | |
| r | 10000 | |
| i | 10000 | |
| 3 | 5287 | |
| 0 | 5287 | |
| 1 | 2390 | 3.6% |
| 7 | 2323 | 3.5% |
| 4 | 813 | 1.2% |
streaming
Boolean
High correlation
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 9.9 KiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 6379 | |
| True | 3621 |
gaming
Boolean
High correlation
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 9.9 KiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 7950 | |
| True | 2050 | 20.5% |
social_media
Boolean
High correlation
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 9.9 KiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 8007 | |
| True | 1993 | 19.9% |
target_offer
Categorical
High correlation
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 637.4 KiB |
| General Offer | |
|---|---|
| Allrounder offer | |
| Streaming partner offer | |
| Stream and social media offer | |
| Social media offer | 365 |
Length
| Max length | 29 |
|---|---|
| Median length | 13 |
| Mean length | 16.2537 |
| Min length | 13 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | General Offer |
|---|---|
| 2nd row | Streaming partner offer |
| 3rd row | General Offer |
| 4th row | General Offer |
| 5th row | General Offer |
Common Values
| Value | Count | Frequency (%) |
| General Offer | 5607 | |
| Allrounder offer | 2050 | 20.5% |
| Streaming partner offer | 1181 | 11.8% |
| Stream and social media offer | 797 | 8.0% |
| Social media offer | 365 | 3.6% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| offer | 10000 | |
| general | 5607 | |
| allrounder | 2050 | 8.6% |
| streaming | 1181 | 4.9% |
| partner | 1181 | 4.9% |
| social | 1162 | 4.9% |
| media | 1162 | 4.9% |
| stream | 797 | 3.3% |
| and | 797 | 3.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 27585 | |
| r | 24047 | |
| f | 20000 | |
| 13937 | ||
| a | 11887 | |
| l | 10869 | 6.7% |
| n | 10816 | 6.7% |
| o | 7605 | 4.7% |
| G | 5607 | 3.4% |
| O | 5607 | 3.4% |
| Other values (11) | 24577 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 162537 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 27585 | |
| r | 24047 | |
| f | 20000 | |
| 13937 | ||
| a | 11887 | |
| l | 10869 | 6.7% |
| n | 10816 | 6.7% |
| o | 7605 | 4.7% |
| G | 5607 | 3.4% |
| O | 5607 | 3.4% |
| Other values (11) | 24577 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 162537 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 27585 | |
| r | 24047 | |
| f | 20000 | |
| 13937 | ||
| a | 11887 | |
| l | 10869 | 6.7% |
| n | 10816 | 6.7% |
| o | 7605 | 4.7% |
| G | 5607 | 3.4% |
| O | 5607 | 3.4% |
| Other values (11) | 24577 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 162537 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 27585 | |
| r | 24047 | |
| f | 20000 | |
| 13937 | ||
| a | 11887 | |
| l | 10869 | 6.7% |
| n | 10816 | 6.7% |
| o | 7605 | 4.7% |
| G | 5607 | 3.4% |
| O | 5607 | 3.4% |
| Other values (11) | 24577 |
Interactions
Correlations
| avg_call_duration | avg_data_usage_gb | complaint_count | device_brand | duration | gaming | monthly_spend | pct_video_usage | plan_type | product_id | product_name | sms_freq | social_media | spending_tier | streaming | target_offer | topup_freq | travel_score | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| avg_call_duration | 1.000 | -0.013 | -0.010 | 0.000 | 0.019 | 0.000 | -0.012 | -0.007 | 0.000 | 0.014 | 0.011 | 0.008 | 0.030 | 0.021 | 0.000 | 0.000 | -0.002 | -0.016 |
| avg_data_usage_gb | -0.013 | 1.000 | 0.008 | 0.000 | 0.014 | 0.021 | 0.854 | 0.024 | 0.000 | -0.027 | 0.016 | -0.008 | 0.000 | 0.661 | 0.021 | 0.011 | 0.018 | 0.010 |
| complaint_count | -0.010 | 0.008 | 1.000 | 0.010 | 0.000 | 0.008 | 0.007 | -0.003 | 0.015 | -0.004 | 0.000 | -0.002 | 0.000 | 0.000 | 0.000 | 0.000 | 0.001 | -0.017 |
| device_brand | 0.000 | 0.000 | 0.010 | 1.000 | 0.012 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.004 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.002 | 0.000 |
| duration | 0.019 | 0.014 | 0.000 | 0.012 | 1.000 | 0.314 | 0.003 | 0.000 | 0.000 | 0.870 | 0.999 | 0.013 | 0.295 | 0.017 | 0.284 | 0.341 | 0.000 | 0.013 |
| gaming | 0.000 | 0.021 | 0.008 | 0.000 | 0.314 | 1.000 | 0.000 | 0.000 | 0.000 | 0.870 | 0.999 | 0.008 | 0.261 | 0.000 | 0.464 | 1.000 | 0.000 | 0.000 |
| monthly_spend | -0.012 | 0.854 | 0.007 | 0.000 | 0.003 | 0.000 | 1.000 | 0.019 | 0.000 | -0.035 | 0.000 | -0.005 | 0.000 | 0.901 | 0.024 | 0.017 | 0.010 | 0.014 |
| pct_video_usage | -0.007 | 0.024 | -0.003 | 0.000 | 0.000 | 0.000 | 0.019 | 1.000 | 0.022 | -0.008 | 0.000 | 0.021 | 0.000 | 0.014 | 0.000 | 0.000 | -0.008 | -0.001 |
| plan_type | 0.000 | 0.000 | 0.015 | 0.000 | 0.000 | 0.000 | 0.000 | 0.022 | 1.000 | 0.000 | 0.008 | 0.028 | 0.006 | 0.000 | 0.000 | 0.000 | 0.028 | 0.008 |
| product_id | 0.014 | -0.027 | -0.004 | 0.000 | 0.870 | 0.870 | -0.035 | -0.008 | 0.000 | 1.000 | 0.999 | 0.006 | 0.647 | 0.015 | 0.808 | 0.686 | -0.019 | 0.001 |
| product_name | 0.011 | 0.016 | 0.000 | 0.004 | 0.999 | 0.999 | 0.000 | 0.000 | 0.008 | 0.999 | 1.000 | 0.010 | 0.999 | 0.000 | 0.999 | 0.999 | 0.000 | 0.014 |
| sms_freq | 0.008 | -0.008 | -0.002 | 0.000 | 0.013 | 0.008 | -0.005 | 0.021 | 0.028 | 0.006 | 0.010 | 1.000 | 0.000 | 0.004 | 0.000 | 0.000 | 0.012 | 0.002 |
| social_media | 0.030 | 0.000 | 0.000 | 0.000 | 0.295 | 0.261 | 0.000 | 0.000 | 0.006 | 0.647 | 0.999 | 0.000 | 1.000 | 0.000 | 0.472 | 0.831 | 0.000 | 0.035 |
| spending_tier | 0.021 | 0.661 | 0.000 | 0.000 | 0.017 | 0.000 | 0.901 | 0.014 | 0.000 | 0.015 | 0.000 | 0.004 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.014 |
| streaming | 0.000 | 0.021 | 0.000 | 0.000 | 0.284 | 0.464 | 0.024 | 0.000 | 0.000 | 0.808 | 0.999 | 0.000 | 0.472 | 0.000 | 1.000 | 0.927 | 0.000 | 0.009 |
| target_offer | 0.000 | 0.011 | 0.000 | 0.000 | 0.341 | 1.000 | 0.017 | 0.000 | 0.000 | 0.686 | 0.999 | 0.000 | 0.831 | 0.000 | 0.927 | 1.000 | 0.000 | 0.000 |
| topup_freq | -0.002 | 0.018 | 0.001 | 0.002 | 0.000 | 0.000 | 0.010 | -0.008 | 0.028 | -0.019 | 0.000 | 0.012 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.001 |
| travel_score | -0.016 | 0.010 | -0.017 | 0.000 | 0.013 | 0.000 | 0.014 | -0.001 | 0.008 | 0.001 | 0.014 | 0.002 | 0.035 | 0.014 | 0.009 | 0.000 | 0.001 | 1.000 |
Missing values
Sample
| customer_id | plan_type | device_brand | avg_data_usage_gb | pct_video_usage | avg_call_duration | sms_freq | monthly_spend | topup_freq | travel_score | complaint_count | product_id | product_name | spending_tier | duration | streaming | gaming | social_media | target_offer | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | C00001 | Prepaid | Realme | 1.50 | 0.804146 | 7.98 | 13 | 70000 | 4 | 0.284419 | 0 | 1 | 10gb 50k (internet only 1) | low | 30 hari | no | no | no | General Offer |
| 1 | C00002 | Postpaid | Vivo | 1.09 | 0.107686 | 9.56 | 9 | 63000 | 3 | 0.115086 | 0 | 18 | 20gb 45k (internet + stream mingguan) | low | 7 hari | yes | no | no | Streaming partner offer |
| 2 | C00003 | Postpaid | Xiaomi | 3.24 | 0.313894 | 4.61 | 13 | 89000 | 7 | 0.402998 | 0 | 15 | 10gb 15k (internet only harian 2) | mid | 1 hari | no | no | no | General Offer |
| 3 | C00004 | Prepaid | Apple | 5.32 | 0.420158 | 6.96 | 8 | 67000 | 4 | 0.302169 | 0 | 2 | 15gb 65k (internet only 2) | low | 30 hari | no | no | no | General Offer |
| 4 | C00005 | Prepaid | Huawei | 1.91 | 0.251638 | 11.01 | 21 | 72000 | 5 | 0.487911 | 0 | 23 | 3gb 8k (internet only hemat 1) | low | 1 hari | no | no | no | General Offer |
| 5 | C00006 | Prepaid | Oppo | 3.30 | 0.478873 | 6.53 | 17 | 54000 | 3 | 0.372135 | 0 | 6 | 80gb 200k (internet only 6) | low | 30 hari | no | no | no | General Offer |
| 6 | C00007 | Prepaid | Oppo | 9.87 | 0.375882 | 11.17 | 11 | 140000 | 5 | 0.308220 | 1 | 7 | 100gb 220k (internet only 7) | mid | 30 hari | no | no | no | General Offer |
| 7 | C00008 | Postpaid | Oppo | 13.91 | 0.465977 | 7.72 | 14 | 180000 | 4 | 0.288257 | 2 | 5 | 50gb 150k (internet only 5) | high | 30 hari | no | no | no | General Offer |
| 8 | C00009 | Postpaid | Realme | 1.25 | 0.222178 | 10.73 | 20 | 72000 | 2 | 0.270601 | 0 | 9 | 35gb 120k (25gb internet + 5gb stream + 5gb socmed, pahe 1) | low | 30 hari | yes | no | yes | Stream and social media offer |
| 9 | C00010 | Postpaid | Huawei | 3.66 | 0.196774 | 13.36 | 11 | 83000 | 1 | 0.342730 | 0 | 5 | 50gb 150k (internet only 5) | mid | 30 hari | no | no | no | General Offer |
| customer_id | plan_type | device_brand | avg_data_usage_gb | pct_video_usage | avg_call_duration | sms_freq | monthly_spend | topup_freq | travel_score | complaint_count | product_id | product_name | spending_tier | duration | streaming | gaming | social_media | target_offer | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9990 | C09991 | Prepaid | Realme | 5.32 | 0.356520 | 14.25 | 14 | 108000 | 4 | 0.138354 | 0 | 22 | 6gb 20k (internet + game mingguan) | mid | 7 hari | no | yes | no | Allrounder offer |
| 9991 | C09992 | Prepaid | Vivo | 12.17 | 0.513754 | 15.62 | 16 | 169000 | 2 | 0.443559 | 0 | 4 | 35gb 100k (internet only 4) | high | 30 hari | no | no | no | General Offer |
| 9992 | C09993 | Prepaid | Samsung | 4.12 | 0.713533 | 13.02 | 13 | 122000 | 4 | 0.299439 | 0 | 16 | 8gb 25k (internet only mingguan 1) | mid | 7 hari | no | no | no | General Offer |
| 9993 | C09994 | Postpaid | Oppo | 2.36 | 0.320020 | 13.29 | 18 | 100000 | 1 | 0.359935 | 0 | 5 | 50gb 150k (internet only 5) | mid | 30 hari | no | no | no | General Offer |
| 9994 | C09995 | Prepaid | Realme | 3.16 | 0.573060 | 6.66 | 11 | 118000 | 0 | 0.265929 | 0 | 3 | 25gb 80k (internet only 3) | mid | 30 hari | no | no | no | General Offer |
| 9995 | C09996 | Postpaid | Huawei | 12.08 | 0.396157 | 6.77 | 11 | 145000 | 1 | 0.235407 | 0 | 15 | 10gb 15k (internet only harian 2) | mid | 1 hari | no | no | no | General Offer |
| 9996 | C09997 | Postpaid | Vivo | 4.49 | 0.504912 | 3.90 | 17 | 106000 | 2 | 0.242680 | 1 | 15 | 10gb 15k (internet only harian 2) | mid | 1 hari | no | no | no | General Offer |
| 9997 | C09998 | Postpaid | Xiaomi | 12.04 | 0.801877 | 20.12 | 21 | 163000 | 4 | 0.159048 | 0 | 7 | 100gb 220k (internet only 7) | high | 30 hari | no | no | no | General Offer |
| 9998 | C09999 | Prepaid | Xiaomi | 11.07 | 0.586104 | 8.04 | 14 | 140000 | 5 | 0.031456 | 1 | 6 | 80gb 200k (internet only 6) | mid | 30 hari | no | no | no | General Offer |
| 9999 | C10000 | Prepaid | Xiaomi | 3.29 | 0.651369 | 13.47 | 16 | 99000 | 4 | 0.275393 | 0 | 1 | 10gb 50k (internet only 1) | mid | 30 hari | no | no | no | General Offer |